Re: explain with placeholders? - Mailing list pgsql-general

From Dan Sugalski
Subject Re: explain with placeholders?
Date
Msg-id a0611040cbd637d99170f@[10.0.1.2]
Whole thread Raw
In response to Re: explain with placeholders?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
At 10:39 AM -0400 9/7/04, Tom Lane wrote:
>Dan Sugalski <dan@sidhe.org> writes:
>>  Is there any way to convince explain to go do its thing when given a
>>  query with placeholders in it?
>
>    PREPARE foo(...) AS SELECT ...
>
>    EXPLAIN EXECUTE foo(...)
>
>EXPLAIN EXECUTE is a relatively recent addition, but I'm sure it's in
>7.4 at least.

Ah, cool. Thanks.
--
                Dan

--------------------------------------it's like this-------------------
Dan Sugalski                          even samurai
dan@sidhe.org                         have teddy bears and even
                                       teddy bears get drunk

pgsql-general by date:

Previous
From: Alex Soto
Date:
Subject: supressing NOTICE messages on Windows/cygwin only not working?
Next
From: "Andrew Janian"
Date:
Subject: Re: ERROR: canceling query due to user request